USE [demo]
GO
/****** Object:  Table [dbo].[EVENT_PATTERN]    Script Date: 06/12/2011 21:13:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[EVENT_PATTERN](
	[PATTERN_ID] [int] IDENTITY(1,1) NOT NULL,
	[PATTERN_GUID] [uniqueidentifier] ROWGUIDCOL  NOT NULL CONSTRAINT [DF_EVENT_PATTERN_PATTERN_GUID]  DEFAULT (newid()),
	[PATTERN_DATE] [datetime] NOT NULL CONSTRAINT [DF_EVENT_PATTERN_PATTERN_DATE]  DEFAULT (getdate()),
	[EXECUTABLE] [nvarchar](256) COLLATE Danish_Norwegian_CI_AS NOT NULL,
	[EVENT_NAME] [nvarchar](256) COLLATE Danish_Norwegian_CI_AS NOT NULL,
	[EVENT_SEVERITY] [nvarchar](256) COLLATE Danish_Norwegian_CI_AS NOT NULL,
	[EVENT_CATEGORY] [nvarchar](256) COLLATE Danish_Norwegian_CI_AS NOT NULL,
	[SEQ_NAME] [nvarchar](50) COLLATE Danish_Norwegian_CI_AS NOT NULL,
	[SEQ_NUMBER] [int] NOT NULL,
	[SEQ_SIZE] [int] NOT NULL,
	[CLASS_NAME] [nvarchar](256) COLLATE Danish_Norwegian_CI_AS NULL,
	[METHOD_NAME] [nvarchar](256) COLLATE Danish_Norwegian_CI_AS NOT NULL,
	[DIRECTION_TYPE] [nvarchar](50) COLLATE Danish_Norwegian_CI_AS NOT NULL
) ON [PRIMARY]
